package com.info.dpunified.common.utils;

public interface SQLConstants {

	final String DEFECTS_SELECT_CRITERIA = "SELECT DISTINCT MONTH, YEAR, " +
			"A.PROJECTCODE PROJECTCODE,A.DEFECTTYPE DEFECTTYPE,A.DEFECTSTATUS DEFECTSTATUS, " +
			"A.DEFECTSEVERITY DEFECTSEVERITY,A.DEFECTPRIORITY DEFECTPRIORITY," +
			"A.DEFECTIMPACT DEFECTIMPACT FROM DPURADARDEFECT A ORDER BY 2,1,3,4,5,6,7,8";
	
	final String FETCH_STATIC_DATA = "SELECT VALUE FROM DPUSTATICDATA WHERE TYPE = ? ORDER BY TYPE";
	
	final String DEFECTS_SUBMITTED_YEARS = "SELECT DISTINCT YEAR FROM DPURADARDEFECT ORDER BY YEAR";
	
	final String DEFECTS_SUBMITTED = "SELECT DISTINCT MONTH, PROJECTCODE, " +
			"'' AS YEAR, '' AS PROJECTCODE, '' AS DEFECTTYPE, " +
			"'' AS DEFECTSTATUS, '' AS DEFECTSEVERITY, '' AS DEFECTPRIORITY, " +
			"'' AS DEFECTIMPACT FROM DPURADARDEFECT WHERE YEAR = ? ORDER BY 1,2";
	
	final String FETCH_MONTHS = "SELECT MONTHS FROM DPUSTATIC DATA";
	
	final String ALL = "ALL";
	final String MATCH_FULL = "%";
	final String AND = " AND ";
}
